Because RESULT_CACHE
-enabled functions increase memory consumption, one should double-check that the gain in performances is
significant, and avoid over-using this feature in general.
Noncompliant code example
CREATE FUNCTION myFastFunction RETURN PLS_INTEGER RESULT_CACHE AS -- Noncompliant
BEGIN
RETURN 42;
END;
/
DROP FUNCTION myFastFunction;